SELECT s.selishte_id, sp.ime, s.selishte_up_id, spbg.ime, COUNT(ob.obqva_id) AS broi_ob, s.selishted FROM selishte s LEFT JOIN selishte_prevod sp ON s.selishte_id = sp.selishte_id AND sp.ezik_id = 1 LEFT JOIN selishte_prevod spbg ON s.selishte_id = spbg.selishte_id AND spbg.ezik_id = 1 LEFT JOIN obqva_selishte ob ON s.selishte_id = ob.selishte_id GROUP BY s.selishte_id, sp.ime, s.selishte_up_id, spbg.ime, s.selishted ORDER BY sp.ime

SELECT o.obqva_id AS o_id, oo.ime AS o_ime, img.img_id AS i_id, img.ifile AS ifile, img.width_sr AS iw, img.height_sr AS ih, img.width_th AS itw, img.height_th AS ith, sp.selishte_id, sp.ime, oo.opis_txt AS o_descr, o.tip_id AS o_tip, ooe.ime AS e_ime, ooe.opis_txt AS e_descr, o.cena AS o_c, o.cena_ot AS o_co, o.cena_zakvm AS o_ckvm, o.cena_otdo AS o_cotdo, v.akronim AS v_akr, o.text_id AS o_tid, o.kvadratura AS o_k, o.kvadratura_min AS o_km, o.valuta_id AS o_valuta, oo.url AS o_url, o.aktivnost AS o_akt FROM obqva o LEFT JOIN obqva_opisanie oo ON o.obqva_id=oo.obqva_id AND oo.ezik_id=1 LEFT JOIN obqva_opisanie ooe ON o.obqva_id=ooe.obqva_id AND ooe.ezik_id=2 LEFT JOIN obqva_img oi ON o.obqva_id = oi.obqva_id AND oi.red = 1 LEFT JOIN img img ON oi.img_id = img.img_id LEFT JOIN obqva_selishte os ON os.obqva_id = o.obqva_id LEFT JOIN selishte s ON s.selishte_id = os.selishte_id LEFT JOIN selishte sup ON s.selishte_up_id = sup.selishte_id LEFT JOIN obqva_imot oim ON oim.obqva_id = o.obqva_id LEFT JOIN selishte_prevod sp ON s.selishte_id = sp.selishte_id AND sp.ezik_id = 1 LEFT JOIN valuta v ON o.valuta_id=v.valuta_id WHERE o.publikuvaj = 1 AND oim.imot_id IN (48,49,50,51,47) ORDER BY o.aktivnost, o.data_aktualizaciq DESC